An IF Statement with an ELSE condition contains an alternative calculation. If the logical expression is false, control passes to the statement after the ELSE keyword.
Here is an example:
IF (@("FirstAmount") < 1000.00) THEN
$FinalAmount = @("FirstAmount") * .05;
ELSE
$FinalAmount = @("FirstAmount") + 10.00;
END;
RETURN ($FinalAmount)
If the value of the section variable field FirstAmount is less than 1000.00 then the amount is multiplied by .05 and entered in the target variable $FinalAmount.
However, if the value of the section variable field FirstAmount is greater than or equal to 1000.00 then 10.00 is added to the amount and entered in the target variable $FinalAmount.
The value of the $FinalAmount field is then returned to the caller or section variable field.
Use of the keyword connector THEN is optional.
© Copyright 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices